package com.huangpuweb.task.model;

import org.springframework.jdbc.core.RowMapper;

import java.sql.ResultSet;
import java.sql.SQLException;

public class ZyDwdDtReworkPersonHpqRowMapper implements RowMapper<ZyDwdDtReworkPersonHpq>{



	@Override
	public ZyDwdDtReworkPersonHpq mapRow(ResultSet rs, int rowNum) throws SQLException {
		ZyDwdDtReworkPersonHpq  lj= new ZyDwdDtReworkPersonHpq();
		lj.setSt_staffinfo_id(rs.getString("ST_STAFFINFO_ID"));
		lj.setSt_prodopaddrinfo_id(rs.getString("ST_PRODOPADDRINFO_ID"));
		lj.setSt_socialcreditcode(rs.getString("ST_SOCIALCREDITCODE"));
		lj.setSt_enterprise_name(rs.getString("ST_ENTERPRISE_NAME"));
		lj.setSt_management_addr(rs.getString("ST_MANAGEMENT_ADDR"));
		lj.setSt_management_county(rs.getString("ST_MANAGEMENT_COUNTY"));
		lj.setSt_management_street(rs.getString("ST_MANAGEMENT_STREET"));
		lj.setSt_enterprise_user(rs.getString("ST_ENTERPRISE_USER"));
		lj.setSt_enterprise_phone(rs.getString("ST_ENTERPRISE_PHONE"));
		lj.setDt_update(rs.getTimestamp("DT_UPDATE"));
		lj.setDt_apply_update(rs.getTimestamp("DT_APPLY_UPDATE"));
		lj.setDt_rework_time(rs.getTimestamp("DT_REWORK_TIME"));
		lj.setDt_audit(rs.getTimestamp("DT_AUDIT"));
		lj.setSt_audit_result(rs.getString("ST_AUDIT_RESULT"));
		lj.setSt_staff_name(rs.getString("ST_STAFF_NAME"));
		lj.setSt_staff_cretcode(rs.getString("ST_STAFF_CRETCODE"));
		lj.setSt_staff_addr(rs.getString("ST_STAFF_ADDR"));
		lj.setSt_staff_county(rs.getString("ST_STAFF_COUNTY"));
		lj.setSt_staff_street(rs.getString("ST_STAFF_STREET"));
		lj.setNm_keyuser(rs.getInt("NM_KEYUSER"));
		lj.setSt_backsh_time(rs.getTimestamp("ST_BACKSH_TIME"));
		lj.setStaff_rework_time(rs.getTimestamp("STAFF_REWORK_TIME"));
		lj.setDt_staff_update(rs.getTimestamp("DT_STAFF_UPDATE"));
		lj.setStat_date(rs.getString("STAT_DATE"));

		return lj;
	}

}
